Round 1: Technical

✅ Tell me about yourself and any recent projects you have been a part of.

✅ Questions related to your projects.

✅ How would you fetch data from an API, and how would you build a pipeline to process it?

✅ How would you migrate data from an on-premises SQL database to Azure?

✅ How does the Self-Hosted Integration Runtime (SHIR) connect to an on-premises SQL server?

✅ How would you create a pipeline in Azure Data Factory (ADF) to copy only recently modified files from multiple folders in ADLS to an output folder in the same ADLS?

✅ 2-3 scenario-based questions related to ADF pipelines.

✅ How would you connect multiple tables from different databases using a single Linked Service in ADF?

✅ What are the different types of triggers in ADF?

✅ How do you deploy code from DEV to QA and PROD environments?

✅ How do you create a CI/CD pipeline for deployment?

✅ What types of transformations have you performed in your projects?

✅ How can you replace spaces in column names with underscores in source files using ADF and Databricks?

✅ What is SCD Type 2, and how can you implement it?

✅ What are the differences between Data Lake Gen2 and Synapse?

✅ How do you read data from ADLS using SQL Pool in Synapse?

✅ What is a stored procedure, and how is it used?

✅ How would you remove duplicate values in your data?

Round 2: Techno Managerial

✅ Tell me about yourself, the recent project you were part of, and your roles and responsibilities.

✅ How do you create a view in Databricks?

✅ Write a DDL command in Databricks.

✅ What ADF activities have you used in your project?

✅ Are you familiar with ADLS security?

✅ What are the different authentication methods available in ADLS?

✅ How many team members are there in your team and what's your role in the team?

Round 3: HR

✅ Discussion around my experience and projects, some resume-based questions

✅ What are you expecting in your next job role?

✅ How soon can you join the company and what is my preferred location

✅ why did you leave TCS without having an offer in hand?